-- Index Creation
	
IF ( NOT EXISTS( SELECT syso.id FROM sysindexes sysi INNER JOIN sysobjects syso ON sysi.id = syso.id WHERE syso.name = 'tblTechnology' AND sysi.name = 'IDX_Technology_ExpertiseLevel' ) )
CREATE NONCLUSTERED INDEX [IDX_Technology_ExpertiseLevel] ON dbo.[tblTechnology] ( [ExpertiseLevelId] )
GO

IF ( NOT EXISTS( SELECT syso.id FROM sysindexes sysi INNER JOIN sysobjects syso ON sysi.id = syso.id WHERE syso.name = 'tblGoal' AND sysi.name = 'IDX_Goal_Status' ) )
CREATE NONCLUSTERED INDEX [IDX_Goal_Status] ON dbo.[tblGoal] ( [StatusId] )
GO

IF ( NOT EXISTS( SELECT syso.id FROM sysindexes sysi INNER JOIN sysobjects syso ON sysi.id = syso.id WHERE syso.name = 'tblGoalRequiredExpertise' AND sysi.name = 'IDX_GoalRequiredExpertise_Goal' ) )
CREATE NONCLUSTERED INDEX [IDX_GoalRequiredExpertise_Goal] ON dbo.[tblGoalRequiredExpertise] ( [GoalId] )
GO

IF ( NOT EXISTS( SELECT syso.id FROM sysindexes sysi INNER JOIN sysobjects syso ON sysi.id = syso.id WHERE syso.name = 'tblGoalRequiredExpertise' AND sysi.name = 'IDX_GoalRequiredExpertise_Technology' ) )
CREATE NONCLUSTERED INDEX [IDX_GoalRequiredExpertise_Technology] ON dbo.[tblGoalRequiredExpertise] ( [TechnologyId] )
GO

